---------------- chi tiet lai suat --------------

if exists (select name from sysobjects where name like 'Proc_LaiSuat_Update')
	drop procedure Proc_LaiSuat_Update
go

create PROC Proc_LaiSuat_Update (@mucLaiSuat float,@loaiTien int,@lastUpdate datetime)
as
	set tran isolation level read committed
	begin tran
		Update ChiTietLaiSuat
		set MucLS=@mucLaiSuat, LoaiTien=@loaiTien, LastUpdate=@lastUpdate
		return 1
	waitfor delay '00:00:10'
go

------------------------

if exists (select name from sysobjects where name like 'Proc_LaiSuat_XemLaiSuat')
	drop procedure Proc_LaiSuat_XemLaiSuat
go

create PROC Proc_LaiSuat_XemLaiSuat
as
set tran isolation level read committed
begin tran
select * from ChiTietLaiSuat
commit tran
go



